<!DOCTYPE html>
<!-- saved from url=(0182)https://support.office.com/zh-cn/article/%E5%A6%82%E4%BD%95%E6%9B%B4%E6%AD%A3-vlookup-%E5%87%BD%E6%95%B0%E4%B8%AD%E7%9A%84-n-a-%E9%94%99%E8%AF%AF-e037d763-ffc3-4fae-a909-89c482d389b2 -->
<html lang="zh-CN" dir="ltr" class="js"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><script async="" charset="UTF-8" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/meCore.min.js.下载"></script><script async="" charset="UTF-8" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/meBoot.min.js.下载"></script><style type="text/css">@charset "UTF-8";[ng\:cloak],[ng-cloak],[data-ng-cloak],[x-ng-cloak],.ng-cloak,.x-ng-cloak,.ng-hide{display:none !important;}ng\:form{display:block;}.ng-animate-block-transitions{transition:0s all!important;-webkit-transition:0s all!important;}.ng-hide-add-active,.ng-hide-remove{display:block!important;}</style>

	<title>如何更正 VLOOKUP 函数中的 #N/A 错误 - Office 支持</title>
	
	<meta http-equiv="content-language" name="Language" content="zh-CN">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="format-detection" content="telephone=no">
	
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<link rel="shortcut icon" href="https://www.microsoft.com/favicon.ico?v2">
	<link rel="apple-touch-icon" href="https://www.microsoft.com/favicon.ico?v2">
	
	<meta name="twitter:card" value="更正 VLOOKUP 函数中的 #N/A 错误">
	<meta property="og:title" content="如何更正 VLOOKUP 函数中的 #N/A 错误">

	<meta property="og:type" content="article">


	<meta property="og:image" content="//support.office.com/Images/SOC_SharingImage_720x405.png">

	<meta property="og:description" content="更正 VLOOKUP 函数中的 #N/A 错误">

	
			<link rel="canonical" href="https://support.office.com/zh-cn/article/%e5%a6%82%e4%bd%95%e6%9b%b4%e6%ad%a3-vlookup-%e5%87%bd%e6%95%b0%e4%b8%ad%e7%9a%84-n-a-%e9%94%99%e8%af%af-e037d763-ffc3-4fae-a909-89c482d389b2">
	<meta name="description" content="更正 VLOOKUP 函数中的 #N/A 错误">
	<meta name="SupportBridge">
	<meta name="ms.contentlang" content="zh-CHS">
	<meta name="C3_ENABLED" content="True">

			<meta name="intl.version" content="5">
			<meta name="intl.id" content="19019949">

		<meta name="keywords" content="更正 VLOOKUP 函数中的 #N/A 错误">

	

	<meta name="search.applicationSuite" content="Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel">
	<meta name="search.appverid" content="ZXL150, ZXL120, ZXL140, WAE150, XCL150, MXL140, XCA150, XIP160, MXL160, EWT160, EWP160, XLA160, ZXL160, ZXL190, MXL190, ZXL900, MXL900">
	<meta name="search.assetid" content="e037d763-ffc3-4fae-a909-89c482d389b2">

	<meta name="search.audienceType" content="End User">
	<meta name="search.contenttype" content="How To">

	<meta name="search.IsOfficeDoc" content="content">


	<meta name="search.sku" content="Excel, Excel Online, Excel for iPad, Excel for Mac, Excel for Android tablets, Excel for iPhone, Excel for Mac, Excel Mobile, Excel for Windows Phone, Excel for Android phones, Excel">
	<meta name="search.skuid" content="WAE150, XCL150, MXL140, XCA150, XIP160, MXL160, EWT160, EWP160, XLA160, ZXL160">
	<meta name="search.softwareVersion" content="15, 12, 14, 15, 15, 14, 15, 16, 16, 16, 16, 16, 16, 19, 19, 90, 90">
	<meta name="search.version" content="7">

<meta name="search.mkt" content="zh-CN">

	



<meta content="f304c6d3-6516-456c-ad2a-9350c8573ffe" name="ms.correlationId">

<meta name="ms.lang" content="zh-CHS">
<meta name="ms.loc" content="CN">
<meta content="e037d763-ffc3-4fae-a909-89c482d389b2" name="ms.ocpub.assetID">
<meta name="ms.pagetype" content="Article">
<meta name="ms.pltfrm" content="OCPub">
<meta name="ms.prod" content="Office">
<meta name="ms.sitesec" content="Support">
<meta name="ms.sitever" content="1601080737650">




	<meta name="contentlocation" content="https://osizpcusmagenta001.blob.core.windows.net">
	
<script type="text/javascript">
	var varSegmentation = 0;
	var varClickTracking = 0;
	var varCustomerTracking = 1;
	var varCustomerCookies = ["msresearch"];
	var varAutoFirePV = 0;
	var Route = '16000';
	var Ctrl = '010';
</script>
		<meta name="ms.pagescope" content="o365ww">
		<link href="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/css" rel="stylesheet">

	<link href="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/articleCss" rel="stylesheet">


<link href="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/stickyFeedbackCss" rel="stylesheet">

	<link href="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/officeShared" rel="stylesheet">

	
<link rel="stylesheet" href="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/9c-2fd5c9" type="text/css" media="all"><link rel="stylesheet" href="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/override.css" type="text/css">

<link href="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/intl.css" rel="stylesheet">

	
<link href="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/topNavCss" rel="stylesheet">

	<script type="text/javascript">
		var OOGlobal = {
			AutoSuggestEndPoint: "//dgps.support.microsoft.com/API/v1/AutoSuggestion",
			BaseDomain: location.protocol + "//" + location.host,
			Culture: "zh-CN",
			LCID: "2052",
			IsAuthenticated: "False",
			WebAppUrl: "https://office.com/start",
			GUID: "e037d763-ffc3-4fae-a909-89c482d389b2",
			Platform: navigator.platform,
			MixOembedUrl: "https://mix.office.com/oembed/",
			MixWatchUrl: "https://mix.office.com/watch/",
			IsCookieConsentRequired: false
		};
		
	</script>
	

	<script type="text/javascript">
		var ariaToken = '1b3c419f862842df99f49c661508cc63-88b16260-a8e4-4d5d-8055-a5014e02c560-7464';
		var ariaTestTraffic = false;
	</script>

	<script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/clientlogging"></script>


	<script type="text/javascript">
		if (typeof ClientSideLogging !== "undefined" && ClientSideLogging !== null) {
			(function(){
				var pageProperties = {
					cultureName: 'zh-CN',
					helpViewer: HelpViewers.web,
					machineId: 'ODCSUPFRONTEND_IN_1',
					region: 'CUS-000',
					build: '1601080737650'
				}

				ClientSideLogging.setPageProperties(pageProperties);
				ClientSideLogging.addListeners();
			})();
			

		}
	</script>

		<script type="text/javascript">
			if (typeof ClientSideLogging !== "undefined" && ClientSideLogging !== null) {
				ClientSideLogging.addPageProperty(PageProperties.pageType, 'Article');
			}
		</script>

	

<script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/jsll-4.2.7.js.下载"></script>
<script>(window.awa)||document.write('<script src="/bundles/jsll"><\/script>');</script>




<meta name="awa-env" content="Production">
<meta name="awa-stv" content="1601080737650">
<meta name="awa-market" content="zh-CN">
<meta name="awa-asst" content="e037d763-ffc3-4fae-a909-89c482d389b2">

<meta name="awa-pageType" content="Article">
<meta content="o365ww" name="awa-pagescope">
<meta content="office.com" name="awa-prdct">








<meta content="zh-CHS" name="awa-contentlang">
<script async="" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/t.js.下载"></script><style type="text/css">.msame_TxtTrunc{white-space:nowrap;text-overflow:ellipsis;overflow:hidden;word-break:break-all}.msame_Header{display:inline-block;cursor:pointer;font-size:14px;border-width:1px;border-style:solid;border-bottom-style:none;border-color:transparent;width:100%}.msame_Header .msame_screen_reader{overflow:hidden;display:inline-block;width:1px;height:1px;position:absolute}.msame_Header_name{padding-left:12px;max-width:160px;display:inline-block;line-height:64px;vertical-align:top;font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;font-size:86%;color:#505050}.msame_unauth .msame_Header_name{padding-right:12px}.msame_unauth .msame_Header_name:hover{color:#0078d7}.msame_Drop_AI_pic,.msame_Drop_active_pic,.msame_Header_pic{display:inline-block}.msame_Header_piccont{padding-top:14px;padding-bottom:14px;padding-right:12px;padding-left:8px}.msame_Mobile .msame_Header_piccont{padding-top:10px;padding-bottom:10px}.msame_Short .msame_Header_piccont{padding-left:12px}.msame_Header_picframe{width:36px;height:36px;border-radius:50%;overflow:hidden}.msame_Mobile .msame_Header_picframe{width:48px;height:48px}.msame_open .msame_Header_picframe{z-index:3000001;position:relative}.msame_Header_chev{display:none}.msame_Mobile .msame_Header_piccont{padding-right:8px;padding-left:10px}.msame_Mobile .msame_Header_name{line-height:3;font-size:114%;padding-left:10px;padding-right:10px;display:inline-block;vertical-align:top;padding-top:14px}.msame_Mobile.msame_3row .msame_Header_name{padding-top:6px}.msame_Mobile .msame_Header_chev{display:inline-block;line-height:64px;vertical-align:top;padding-right:16px;padding-left:8px;float:right}.msame_open .msame_Header_chev img{-moz-transform:scaleY(-1);-o-transform:scaleY(-1);-webkit-transform:scaleY(-1);transform:scaleY(-1);filter:FlipV;-ms-filter:FlipV}.msame_Drop_root .msame_Drop_AI:focus,.msame_Drop_root .msame_Drop_AI_remove:focus,.msame_Drop_root a:focus,.msame_Header:focus{border-style:dashed;border-color:#000;border-width:1px}.msame_Header .msame_Header_piccont img{width:36px;height:36px;line-height:normal;vertical-align:baseline}.msame_Mobile .msame_Header_piccont img{width:48px;height:48px}.msame_Mobile .msame_Header_fullName{font-size:100%;color:#000;line-height:1.333}.msame_Drop_AI_email,.msame_Drop_AI_status,.msame_Mobile .msame_Header_email,.msame_Mobile .msame_Header_nickName{font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;font-size:86%;color:rgba(0,0,0,.54);line-height:1.333333}.msaie8 .msame_Drop_AI_pic,.msaie8 .msame_Drop_AI_right,.msaie8 .msame_Drop_active_pic,.msaie8 .msame_Drop_active_right,.msaie8 .msame_Header,.msaie8 .msame_Header_name,.msaie8 .msame_Header_pic{zoom:1}</style><script async="" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/t.js(1).下载"></script><style type="text/css">.msame_open .msame_Header{border-color:#e6e6e6;background-color:#fff}.msame_open .msame_Header.msame_Mobile{border-color:transparent;background-color:transparent}.msame_ClickStart.msame_Drop_root .msame_Drop_AI:focus,.msame_ClickStart.msame_Drop_root .msame_Drop_AI_remove:focus,.msame_ClickStart.msame_Drop_root a:focus{outline-style:none}.msame_Drop_root a,.msame_Drop_root a:active,.msame_Drop_root a:focus,.msame_Drop_root a:hover,.msame_Drop_root a:visited{text-decoration:none}.msame_Drop_topb{border-top-color:#e6e6e6;border-top-style:solid;border-top-width:1px}.msame_Mobile .msame_Drop_topb{width:100%!important}.msame_Drop_active{padding-bottom:8px}.msame_Drop_AI_picframe{width:44px;height:44px;border-radius:50%;overflow:hidden}.msame_Drop_AI_piccont img{width:44px;height:44px}.msame_Drop_root{border-width:1px;border-color:#e6e6e6;border-style:solid;border-top-style:none;position:absolute;width:360px;z-index:3000000;background-color:#fff;font-size:14px}.msame_Drop_sep{border-top-width:1px;border-top-color:#e6e6e6;border-top-style:solid;width:100%;height:0;display:block}.msame_Mobile.msame_Drop_root{left:0!important;right:0;bottom:0;width:100%;border-right-width:0;border-left-width:0}.msame_Mobile .msame_Drop_content{overflow-y:auto;position:absolute;left:0;right:0;bottom:0;top:0}.msame_Drop_root a{text-decoration:none}.msame_Drop_content{overflow:hidden}.msame_Mobile .msame_Drop_active{display:none}.msame_Drop_AI{cursor:pointer}.disabled .msame_Drop_AI_pic,.disabled .msame_Drop_AI_right{opacity:.4;cursor:default}.disabled .msame_Drop_AI_email,.disabled .msame_Drop_AI_name,.disabled .msame_Drop_AI_status{color:#000}.msame_Drop_active_piccont{padding:5px}.msame_Drop_AI_piccont{padding:10px}.msame_Drop_active_picframe{width:74px;height:74px;border-radius:50%;overflow:hidden}.msame_Drop_active_picborder,.msame_Drop_active_piccont a{display:block;padding:5px;border-radius:50%}.msame_Drop_active_piccont a:focus{padding:4px;border:1px dashed #000}.msame_Drop_active_piccont img{width:64px;height:64px;border-radius:50%}.msame_Drop_active_name{display:block;line-height:1.3;font-size:150%;color:#000;font-family:"Segoe UI Light","Segoe UI Web Light","Segoe UI Web Regular","Segoe UI","Segoe UI Symbol",HelveticaNeue-Light,"Helvetica Neue",Arial,sans-serif}.msame_Drop_active_email{display:block;line-height:1.42857;font-size:100%;color:rgba(0,0,0,.54);font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;padding:1px}.msame_Drop_active_right{display:inline-block;width:216px;vertical-align:top;padding-top:12px;padding-right:12px;padding-left:12px}.msame_Drop_active_right a{color:rgba(0,0,0,.54)}.msame_Drop_SI a{line-height:2;font-size:114%;font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;padding-left:12px;padding-right:12px;display:block;color:#000}.msame_Mobile .msame_Drop_SI a{line-height:2.75}.msame_Drop_AI.switch:hover,.msame_Drop_AI_remove:hover,.msame_Drop_SI a:hover{color:#000;background-color:rgba(0,0,0,.12)}.msame_Drop_AI.switch:active,.msame_Drop_AI.switch:active div,.msame_Drop_AI_remove:active,.msame_Drop_SI a:active{color:#fff!important;background-color:#000}.msame_Drop_SI a:link,.msame_Drop_SI a:visited{color:#000}.msame_Drop_active_link a,.msame_Drop_active_link a:active,.msame_Drop_active_link a:hover,.msame_Drop_active_link a:link,.msame_Drop_active_link a:visited{line-height:1.333333;font-size:86%;font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;color:#0078d7}.msame_Drop_AL{padding-bottom:24px}.msame_Drop_AI_right{display:inline-block;width:252px;vertical-align:top;padding-left:8px;padding-top:5px}.msame_Mobile .msame_Drop_AI_right{width:100px}.msame_Drop_AI_name{font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;font-size:114%;color:#000;line-height:1.25}.msame_Drop_AI_remove{float:right;margin-top:6px;padding-top:12px;padding-bottom:12px;padding-left:12px;padding-right:12px;text-align:center;cursor:pointer}.msame_Drop_AI_remove img{display:block}.msame_auto_frame{display:none;position:absolute;top:0;left:-4000px;width:0}</style><script async="" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/t.js(2).下载"></script><script async="" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/t.js(3).下载"></script></head>

<body class="supCont ocArticle ">
	<div id="ocBodyWrapper">
		
	

    <section id="headerArea" data-m="{&quot;cN&quot;:&quot;headerArea&quot;,&quot;cT&quot;:&quot;Area_coreuiArea&quot;,&quot;id&quot;:&quot;a1Body&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;Body&quot;}">
            <div id="headerRegion" data-region-key="headerregion" data-m="{&quot;cN&quot;:&quot;headerRegion&quot;,&quot;cT&quot;:&quot;Region_coreui-region&quot;,&quot;id&quot;:&quot;r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;a1&quot;}">

    <div id="headerUniversalHeader" data-m="{&quot;cN&quot;:&quot;headerUniversalHeader&quot;,&quot;cT&quot;:&quot;Module_coreui-universalheader&quot;,&quot;id&quot;:&quot;m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;r1a1&quot;}" data-module-id="Category|headerRegion|headerRegion|headerUniversalHeader|coreui-universalheader">
        



            <div id="epb" class="x-hidden x-hidden-vp1 x-hidden-vp2 uhfc-universal-context context-uhf" data-m="{&quot;cN&quot;:&quot;epb_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;m1r1a1&quot;}">



<div class="c-uhfh-alert f-information epb-container epb-default-color" role="banner" aria-label="banner" data-m="{&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1m1r1a1&quot;}">
    <div>        
        <p class="c-paragraph">
                <img alt="Microsoft Edge" data-src="https://img-prod-cms-rt-microsoft-com.akamaized.net/cms/api/am/imageFileData/REZlo1?ver=5722" src="https://support.office.com/zh-cn/article/%E5%A6%82%E4%BD%95%E6%9B%B4%E6%AD%A3-vlookup-%E5%87%BD%E6%95%B0%E4%B8%AD%E7%9A%84-n-a-%E9%94%99%E8%AF%AF-e037d763-ffc3-4fae-a909-89c482d389b2" class="f-img-lzy" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500">

            <span class="c-text-group">
                <span class="epb-launch">试用- Microsoft Edge</span>
                <span class="epb-text">专为 Windows 10 设计的快速安全的浏览器</span>
            </span>
            <span class="c-group">
                <button id="close-epb" class="c-action-trigger c-action-cancel glyph-cancel" data-m="{&quot;cN&quot;:&quot;EPB-dismiss_nonnav&quot;,&quot;id&quot;:&quot;nn1c1c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c1m1r1a1&quot;}" aria-label="不，谢谢，我稍后再试用 Microsoft Edge。 ">不用了，谢谢</button>
                <a id="epbTryNow" data-telem-qsp="form=MY009W" aria-label="开始：在 Microsoft Edge 中打开此页面" class="epb-launch c-action-trigger c-action-open" data-m="{&quot;cN&quot;:&quot;EPB-launch_nav&quot;,&quot;id&quot;:&quot;n2c1c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c1m1r1a1&quot;}" ms.cmpgrp="content" ms.pgarea="Body">入门</a>
            </span>

        </p>
    </div>
</div>


                
            </div>





<header role="region" class="c-uhfh context-uhf" itemscope="itemscope" data-header-footprint="/officesupport/officesupportheader" data-ckrate="1" data-magict="true" itemtype="http://schema.org/Organization">
    <div class="theme-light js-global-head f-closed " data-m="{&quot;cN&quot;:&quot;Universal Header_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1m1r1a1&quot;}">
        <div class="c-uhfh-gcontainer">
            <button type="button" class="c-action-trigger c-glyph glyph-global-nav-button" aria-label="标题导航菜单" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;Mobile menu button_nonnav&quot;,&quot;id&quot;:&quot;nn1c2c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}"></button>
            <button type="button" class="c-action-trigger c-glyph glyph-arrow-htmllegacy" aria-label="关闭搜索" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;Close Search_nonnav&quot;,&quot;id&quot;:&quot;nn2c2c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}"></button>
                    <a id="uhfLogo" class="c-logo" itemprop="url" href="https://www.microsoft.com/" aria-label="Microsoft" data-m="{&quot;cN&quot;:&quot;GlobalNav_Logo_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c2c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}" data-bi-name="Microsoft" ms.cmpgrp="content" ms.pgarea="Body">
                        <img alt="Microsoft" itemprop="logo" itemscope="itemscope" class="c-image" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/RE1Mu3b" role="presentation" ms.cmpgrp="content" ms.pgarea="Body">
                        <span role="presentation">Microsoft</span>
                    </a>
            <div class="f-mobile-title">
                <button type="button" class="c-action-trigger c-glyph glyph-chevron-left" aria-label="查看更多菜单选项" data-m="{&quot;cN&quot;:&quot;Mobile back button_nonnav&quot;,&quot;id&quot;:&quot;nn4c2c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}"></button>
                <span data-global-title="Microsoft 主页" class="js-mobile-title">Office</span>
                <button type="button" class="c-action-trigger c-glyph glyph-chevron-right" aria-label="查看更多菜单选项" data-m="{&quot;cN&quot;:&quot;Mobile forward button_nonnav&quot;,&quot;id&quot;:&quot;nn5c2c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}"></button>
            </div>

            
            <button type="button" class="c-action-trigger c-glyph glyph-chevron-left js-primary-paddle" data-m="{&quot;cN&quot;:&quot;Previous_nonnav&quot;,&quot;id&quot;:&quot;nn6c2c1m1r1a1&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}" aria-label="Show previous" tabindex="-1"></button>
            
            
            
            <button type="button" class="c-action-trigger c-glyph glyph-chevron-right js-secondary-paddle" data-m="{&quot;cN&quot;:&quot;Next_nonnav&quot;,&quot;id&quot;:&quot;nn7c2c1m1r1a1&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}" aria-label="Show next" tabindex="-1"></button>

                <div class="c-uhfh-actions" data-m="{&quot;cN&quot;:&quot;Header actions_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c8c2c1m1r1a1&quot;,&quot;sN&quot;:8,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}">
                                <form class="c-search ng-scope ng-pristine ng-valid" autocomplete="off" id="searchForm" name="searchForm" role="search" action="https://support.office.com/zh-cn/Search/results" method="GET" data-seautosuggest="{&quot;queryParams&quot;:{&quot;market&quot;:&quot;zh-cn&quot;,&quot;clientId&quot;:&quot;7F27B536-CF6B-4C65-8638-A0F8CBDFCA65&quot;,&quot;sources&quot;:&quot;Microsoft-Terms,Iris-Products,DCatAll-Products&quot;,&quot;filter&quot;:&quot;ExcludeDCatProducts:DCatDevices-Products,DCatSoftware-Products,DCatBundles-Products+ClientType:StoreWeb&quot;,&quot;counts&quot;:&quot;5,1,5&quot;},&quot;familyNames&quot;:{&quot;Apps&quot;:&quot;应用&quot;,&quot;Books&quot;:&quot;书籍&quot;,&quot;Bundles&quot;:&quot;套装&quot;,&quot;Devices&quot;:&quot;设备&quot;,&quot;Fees&quot;:&quot;Fee&quot;,&quot;Games&quot;:&quot;游戏&quot;,&quot;MusicAlbums&quot;:&quot;专辑&quot;,&quot;MusicTracks&quot;:&quot;歌曲&quot;,&quot;MusicVideos&quot;:&quot;视频&quot;,&quot;MusicArtists&quot;:&quot;艺术家&quot;,&quot;OperatingSystem&quot;:&quot;操作系统&quot;,&quot;Software&quot;:&quot;软件&quot;,&quot;Movies&quot;:&quot;影片&quot;,&quot;TV&quot;:&quot;电视&quot;,&quot;CSV&quot;:&quot;礼品卡&quot;,&quot;VideoActor&quot;:&quot;表演者&quot;}}" data-seautosuggestapi="https://www.microsoft.com/services/api/v3/suggest" data-m="{&quot;cN&quot;:&quot;GlobalNav_Search_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c8c2c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c8c2c1m1r1a1&quot;}" aria-expanded="false" ng-controller="autoSuggestController as main">
                <input id="cli_shellHeaderSearchInput" aria-label="搜索 Office 帮助" aria-autocomplete="both" aria-controls="universal-header-search-auto-suggest-transparent" aria-owns="universal-header-search-auto-suggest-ul" type="search" name="query" placeholder="搜索 Office 帮助" data-m="{&quot;cN&quot;:&quot;SearchBox_nav&quot;,&quot;id&quot;:&quot;n1c1c8c2c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c8c2c1m1r1a1&quot;}" ng-model="main.searchText" ng-change="main.fireAutoSuggest()" class="ng-pristine ng-valid" style="display: inline-block;"><div class="x-screen-reader" aria-live="assertive"></div>
                <button id="search" aria-label="搜索" class="c-glyph" data-m="{&quot;cN&quot;:&quot;Search_nav&quot;,&quot;id&quot;:&quot;n2c1c8c2c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c8c2c1m1r1a1&quot;}" data-bi-dnt="true" data-bi-mto="true"></button>
                <div class="m-auto-suggest" id="universal-header-search-auto-suggest-transparent" role="group">
                    <ul class="c-menu" id="universal-header-search-auto-suggest-ul" aria-hidden="true" data-bi-dnt="true" data-bi-mto="true" data-js-auto-suggest-position="default" role="listbox" data-tel="jsll" data-m="{&quot;cN&quot;:&quot;search suggestions_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c1c8c2c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1c8c2c1m1r1a1&quot;}"></ul>
                </div>
                
            <input type="text" id="supSuggestionHider" ng-init="main.tenant = &#39;web&#39;" ng-model="main.tenant" class="ng-pristine ng-valid"><auto-suggest search-input-box="#cli_shellHeaderSearchInput" search-submit="#search" search-input-type="button" suggestions="main.suggestions" search-text="main.searchText" show-suggestions="main.showSuggestions" selected-item="main.selectedItem" class="ng-isolate-scope"><span class="supAutoSuggestAccessibleText" role="status" aria-live="polite"></span><div class="supAutoSuggestContainer ng-hide" ng-show="showSuggestions"><ul class="supSuggestionList"><!-- ngRepeat: suggestion in suggestions --></ul></div></auto-suggest></form>

                                <a id="uhf-shopping-cart" aria-label="0 购物车中的物品" class="c-action-trigger c-glyph glyph-shopping-cart" href="https://www.microsoftstore.com.cn/cart" title="查看购物车" data-m="{&quot;cN&quot;:&quot;GlobalNav_Cart_nav&quot;,&quot;bhvr&quot;:82,&quot;id&quot;:&quot;n2c8c2c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c8c2c1m1r1a1&quot;}" ms.cmpgrp="content" ms.pgarea="Body">
                <span class="shopping-cart-amount x-hidden" aria-hidden="true">0</span>
            </a>
                <iframe id="shell-cart-count" title="购物车中的物品" data-src="//www.microsoftstore.com.cn/cart" style="display: none" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/cart.html"></iframe>

                    
                                <div id="meControl" class="c-me" data-signinsettings="{&quot;containerId&quot;:&quot;meControl&quot;,&quot;enabled&quot;:true,&quot;headerHeight&quot;:48,&quot;debug&quot;:false,&quot;extensibleLinks&quot;:[],&quot;userData&quot;:{&quot;idp&quot;:&quot;msa&quot;,&quot;firstName&quot;:&quot;&quot;,&quot;lastName&quot;:&quot;&quot;,&quot;memberName&quot;:&quot;&quot;,&quot;cid&quot;:&quot;&quot;,&quot;authenticatedState&quot;:&quot;3&quot;},&quot;rpData&quot;:{&quot;preferredIdp&quot;:&quot;msa&quot;,&quot;msaInfo&quot;:{&quot;signInUrl&quot;:&quot;https://www.office.com/login?ru=%2f%3fauth%3d1\u0026es=click &quot;,&quot;signOutUrl&quot;:&quot;&quot;,&quot;meUrl&quot;:&quot;https://login.live.com/me.srf?wa=wsignin1.0&quot;},&quot;aadInfo&quot;:{&quot;signOutUrl&quot;:&quot;&quot;,&quot;appId&quot;:&quot;&quot;,&quot;siteUrl&quot;:&quot;&quot;,&quot;blockMsaFed&quot;:true}}}" data-m="{&quot;cN&quot;:&quot;GlobalNav_Account_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c8c2c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c8c2c1m1r1a1&quot;}"><div><div class="msame_header_focus_trap" tabindex="0" aria-hidden="true" style="display: none;"></div><div class="msame_Header msame_unauth" role="button" tabindex="0" aria-label="请登录你的帐户" title="请登录你的帐户" data-mc-m="{&quot;id&quot;:&quot;headerClick&quot;,&quot;aN&quot;:&quot;Me Control Header&quot;,&quot;cT&quot;:&quot;Button&quot;}" "="" style="height: 48px;"><span class="msame_screen_reader">请登录你的帐户</span><div aria-hidden="true" role="presentation"><div class="msame_Header_name msame_TxtTrunc" style="line-height: 48px;">登录</div><div class="msame_Header_chev"></div></div></div><div class="msame_header_focus_trap" tabindex="0" aria-hidden="true" style="display: none;"></div></div></div>

                    
                </div>
        </div>
        
        
    </div>
                <div class="theme-dark brand-neutral js-cat-head" itemprop="brand" itemscope="itemscope" itemtype="http://schema.org/Brand" data-m="{&quot;cN&quot;:&quot;UHF category nav_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1m1r1a1&quot;}" ms.pgarea="Header">

<div>
        <a id="uhfCatLogo" class="c-logo" href="https://www.office.com/" aria-label="Office" itemprop="url" data-m="{&quot;cN&quot;:&quot;Office_nav&quot;,&quot;id&quot;:&quot;n1c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" ms.pgarea="Body">
                <span>Office</span>
        </a>
    <a id="buyinstallbutton" class="c-call-to-action c-glyph" aria-label="购买 Office 365" data-m="{&quot;cN&quot;:&quot;购买 Office 365&quot;,&quot;cT&quot;:&quot;0&quot;,&quot;id&quot;:&quot;n2c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" href="https://go.microsoft.com/fwlink/?linkid=849747" ms.pgarea="Body">
                <span>购买 Office 365</span>
            </a>

    <button class="c-action-trigger c-glyph glyph-chevron-left js-primary-paddle" aria-label="向左滚动" title="向左滚动" data-m="{&quot;cN&quot;:&quot;Previous_nonnav&quot;,&quot;id&quot;:&quot;nn3c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" tabindex="-1" style="display: none;"></button>
    
    <button class="c-action-trigger c-glyph glyph-chevron-right js-secondary-paddle" aria-label="向右滚动" title="向右滚动" data-m="{&quot;cN&quot;:&quot;Next_nonnav&quot;,&quot;id&quot;:&quot;nn4c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" tabindex="-1" style="display: none;"></button>
            <nav id="uhf-c-nav" role="navigation" aria-label="office" class="js-paddle-items">

<div class="c-uhf-menu js-nav-menu" role="presentation" style="transition: margin 0.667s cubic-bezier(0.16, 1, 0.29, 0.99); margin-left: 0px;">
                        <button type="button" id="Products" aria-expanded="false" aria-haspopup="true" data-m="{&quot;cN&quot;:&quot;CatNav_Products_nonnav&quot;,&quot;id&quot;:&quot;nn5c3c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}">产品</button>
                        <ul class=" f-multi-column f-multi-column-4" aria-labelledby="Products" aria-hidden="true" data-m="{&quot;cN&quot;:&quot;Products_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c6c3c1m1r1a1&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}">
        <li class="f-sub-menu js-nav-menu" data-m="{&quot;cN&quot;:&quot;ForHome_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c6c3c1m1r1a1&quot;}">

            <button type="button" id="家用版&gt;-navigation" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;CatNav_ForHome_nonnav&quot;,&quot;id&quot;:&quot;nn1c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">家用版 &gt;</button>
            <ul aria-labelledby="家用版&gt;-navigation" aria-hidden="true">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;HomePlansPricing_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">
            <a id="HomePlansPricing" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/compare-all-microsoft-office-products?tab=1" data-m="{&quot;cN&quot;:&quot;CatNav_HomePlansPricing_nav&quot;,&quot;id&quot;:&quot;n1c2c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c1c6c3c1m1r1a1&quot;}" ms.pgarea="Body">计划与定价</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;for-households_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">
            <a id="for-households" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/office-365-home" data-m="{&quot;cN&quot;:&quot;CatNav_for-households_nav&quot;,&quot;id&quot;:&quot;n1c3c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c1c6c3c1m1r1a1&quot;}" ms.pgarea="Body">家用版</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;for-individuals_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">
            <a id="for-individuals" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/office-365-personal" data-m="{&quot;cN&quot;:&quot;CatNav_for-individuals_nav&quot;,&quot;id&quot;:&quot;n1c4c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c1c6c3c1m1r1a1&quot;}" ms.pgarea="Body">个人版</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;HomeSeeAllHome_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c5c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">
            <a id="HomeSeeAllHome" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/explore-office-for-home" data-m="{&quot;cN&quot;:&quot;CatNav_HomeSeeAllHome_nav&quot;,&quot;id&quot;:&quot;n1c5c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c5c1c6c3c1m1r1a1&quot;}" ms.pgarea="Body">“查看全部”主页</a>
            
        </li>
            </ul>
            
        </li>
        <li class="f-sub-menu js-nav-menu" data-m="{&quot;cN&quot;:&quot;ForBusiness_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c6c3c1m1r1a1&quot;}">

            <button type="button" id="商业版&gt;-navigation" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;CatNav_ForBusiness_nonnav&quot;,&quot;id&quot;:&quot;nn1c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">商业版 &gt;</button>
            <ul aria-labelledby="商业版&gt;-navigation" aria-hidden="true">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;PlansPricing_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="PlansPricing" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/compare-all-microsoft-office-products?tab=2" data-m="{&quot;cN&quot;:&quot;CatNav_PlansPricing_nav&quot;,&quot;id&quot;:&quot;n1c2c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">计划与定价</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Smallbusiness_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="SmallBusiness" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/business/explore-office-365-for-business" data-m="{&quot;cN&quot;:&quot;CatNav_Smallbusiness_nav&quot;,&quot;id&quot;:&quot;n1c3c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">小型企业版</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Enterprise_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="Enterprise" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/business/enterprise-productivity-tools" data-m="{&quot;cN&quot;:&quot;CatNav_Enterprise_nav&quot;,&quot;id&quot;:&quot;n1c4c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">企业版</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;FrontlineWorkers_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c5c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="FrontlineWorkers" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/business/enterprise-firstline-workers" data-m="{&quot;cN&quot;:&quot;CatNav_FrontlineWorkers_nav&quot;,&quot;id&quot;:&quot;n1c5c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c5c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">一线员工</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;SeeAllBusiness_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c6c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="SeeAllBusiness" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-CN/business/office" data-m="{&quot;cN&quot;:&quot;CatNav_SeeAllBusiness_nav&quot;,&quot;id&quot;:&quot;n1c6c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c6c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">查看所有商业版</a>
            
        </li>
            </ul>
            
        </li>
        <li class="f-sub-menu js-nav-menu" data-m="{&quot;cN&quot;:&quot;ForEducation_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c6c3c1m1r1a1&quot;}">

            <button type="button" id="教育版&gt;-navigation" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;CatNav_ForEducation_nonnav&quot;,&quot;id&quot;:&quot;nn1c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c6c3c1m1r1a1&quot;}">教育版 &gt;</button>
            <ul aria-labelledby="教育版&gt;-navigation" aria-hidden="true">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Studentsteachers_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c3c6c3c1m1r1a1&quot;}">
            <a id="Studentsteachers" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/home-and-student" data-m="{&quot;cN&quot;:&quot;CatNav_Studentsteachers_nav&quot;,&quot;id&quot;:&quot;n1c2c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c3c6c3c1m1r1a1&quot;}" ms.pgarea="Body">面向学生和教师</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Schools_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c3c6c3c1m1r1a1&quot;}">
            <a id="Schools" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/academic/office-365-education-plan" data-m="{&quot;cN&quot;:&quot;CatNav_Schools_nav&quot;,&quot;id&quot;:&quot;n1c3c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c3c6c3c1m1r1a1&quot;}" ms.pgarea="Body">面向学校</a>
            
        </li>
            </ul>
            
        </li>
        <li class="f-sub-menu js-nav-menu" data-m="{&quot;cN&quot;:&quot;applications_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c6c3c1m1r1a1&quot;}">

            <button type="button" id="应用程序&gt;-navigation" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;CatNav_applications_nonnav&quot;,&quot;id&quot;:&quot;nn1c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">应用程序 &gt;</button>
            <ul aria-labelledby="应用程序&gt;-navigation" aria-hidden="true">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;outlook_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="outlook" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/outlook/email-and-calendar-software-microsoft-outlook" data-m="{&quot;cN&quot;:&quot;CatNav_outlook_nav&quot;,&quot;id&quot;:&quot;n1c2c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">Outlook</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;onedrive-for-business_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="onedrive-for-business" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/onedrive-for-business/online-cloud-storage" data-m="{&quot;cN&quot;:&quot;CatNav_onedrive-for-business_nav&quot;,&quot;id&quot;:&quot;n1c3c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">OneDrive</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;word_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="word" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/word" data-m="{&quot;cN&quot;:&quot;CatNav_word_nav&quot;,&quot;id&quot;:&quot;n1c4c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">Word</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;excel_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c5c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="excel" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/excel" data-m="{&quot;cN&quot;:&quot;CatNav_excel_nav&quot;,&quot;id&quot;:&quot;n1c5c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c5c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">Excel</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;powerpoint_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c6c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="powerpoint" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/powerpoint" data-m="{&quot;cN&quot;:&quot;CatNav_powerpoint_nav&quot;,&quot;id&quot;:&quot;n1c6c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c6c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">PowerPoint</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;onenote_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c7c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="onenote" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/onenote/digital-note-taking-app" data-m="{&quot;cN&quot;:&quot;CatNav_onenote_nav&quot;,&quot;id&quot;:&quot;n1c7c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c7c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">OneNote</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;sharepoint_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c8c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:8,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="sharepoint" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/sharepoint/collaboration" data-m="{&quot;cN&quot;:&quot;CatNav_sharepoint_nav&quot;,&quot;id&quot;:&quot;n1c8c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c8c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">SharePoint</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;microsoft-teams_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c9c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:9,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="microsoft-teams" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/microsoft-teams/group-chat-software" data-m="{&quot;cN&quot;:&quot;CatNav_microsoft-teams_nav&quot;,&quot;id&quot;:&quot;n1c9c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c9c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">Microsoft Teams</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;see-all-office-products_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c10c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:10,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="see-all-office-products" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/products" data-m="{&quot;cN&quot;:&quot;CatNav_see-all-office-products_nav&quot;,&quot;id&quot;:&quot;n1c10c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c10c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">查看所有 Office 产品</a>
            
        </li>
            </ul>
            
        </li>
                            
                        </ul>
                    </div><div class="c-uhf-menu js-nav-menu" role="presentation">
                        <button type="button" id="resources" aria-expanded="false" aria-haspopup="true" data-m="{&quot;cN&quot;:&quot;CatNav_Resources_nonnav&quot;,&quot;id&quot;:&quot;nn7c3c1m1r1a1&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}">资讯</button>
                        <ul class="" aria-labelledby="resources" aria-hidden="true" data-m="{&quot;cN&quot;:&quot;Resources_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c8c3c1m1r1a1&quot;,&quot;sN&quot;:8,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Training_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c8c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c8c3c1m1r1a1&quot;}">
            <a id="Training" class="js-subm-uhf-nav-link" href="https://support.office.com/zh-cn/office-training-center?ms.officeurl=training" data-m="{&quot;cN&quot;:&quot;CatNav_Training_nav&quot;,&quot;id&quot;:&quot;n1c1c8c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c8c3c1m1r1a1&quot;}" ms.pgarea="Body">培训</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;SetupAndInstall_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c8c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c8c3c1m1r1a1&quot;}">
            <a id="SetupAndInstall" class="js-subm-uhf-nav-link" href="https://support.office.com/zh-cn/article/download-and-install-or-reinstall-office-365-or-office-2016-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658" data-m="{&quot;cN&quot;:&quot;CatNav_SetupAndInstall_nav&quot;,&quot;id&quot;:&quot;n1c2c8c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c8c3c1m1r1a1&quot;}" ms.pgarea="Body">安装程序和安装</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;FAQ_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c8c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c8c3c1m1r1a1&quot;}">
            <a id="FAQ" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-CN/microsoft-office-for-home-and-school-faq" data-m="{&quot;cN&quot;:&quot;CatNav_FAQ_nav&quot;,&quot;id&quot;:&quot;n1c3c8c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c8c3c1m1r1a1&quot;}" ms.pgarea="Body">常见问题</a>
            
        </li>
                            
                        </ul>
                    </div>                        <a id="c-shellmenu_29" class="c-uhf-nav-link" href="https://templates.office.com/" data-m="{&quot;cN&quot;:&quot;CatNav_Templates_nav&quot;,&quot;id&quot;:&quot;n9c3c1m1r1a1&quot;,&quot;sN&quot;:9,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" ms.pgarea="Body">模板</a>
                        <a id="shell-main-tab" class="c-uhf-nav-link f-current" href="https://support.office.com/" data-m="{&quot;cN&quot;:&quot;CatNav_Support_nav&quot;,&quot;id&quot;:&quot;n10c3c1m1r1a1&quot;,&quot;sN&quot;:10,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" ms.pgarea="Body">支持</a>
            <a id="mobile-buyInstallButton" class="c-uhf-nav-link x-hidden x-visible-vp2-block x-visible-vp1-block" href="https://go.microsoft.com/fwlink/?linkid=849747" data-m="{&quot;cN&quot;:&quot;CatNav_购买 Office 365_nav&quot;,&quot;id&quot;:&quot;n11c3c1m1r1a1&quot;,&quot;sN&quot;:11,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" ms.pgarea="Body">购买 Office 365</a>
        </nav>

</div>


                
            </div>

    
</header>


    </div>
    </div>

    </section>



		





	<div id="topNav" class="topNav " ms.pgarea="topnav" data-bi-area="topnav">
		<div id="topNavMobileDropdown">
			<div class="topNavMobileCategory" id="topNavMobileDropdownButton">
				<a class="topNavDropdownTrigger" href="javascript:" aria-expanded="false" aria-label="支持" ms.cmpgrp="content" ms.pgarea="Body" data-bi-bhvr="EXPAND">
					<span>支持</span>
					<span class="topNavChevron ms-Icon--chevronThinDown"></span>
				</a>
			</div>
		</div>
		<ul id="topNavCategories">
						<li class="topNavCategory" ms.cmpgrp="apps">
							<a class="topNavDropdownTrigger" href="javascript:" ms.interactiontype="11" aria-expanded="False" aria-label="应用" data-bi-name="应用" data-bi-slot="100" data-bi-bhvr="EXPAND" ms.cmpgrp="content" ms.pgarea="Body">
								<span>应用</span>
								<span class="topNavChevron ms-Icon--chevronThinDown"></span>
							</a>
							<ul class="topNavDropdownMenu">
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/outlook" class="topNavDropdownLink" data-bi-name="Outlook" data-bi-slot="101" ms.cmpgrp="content" ms.pgarea="Body">Outlook</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/onedrive" class="topNavDropdownLink" data-bi-name="OneDrive" data-bi-slot="102" ms.cmpgrp="content" ms.pgarea="Body">OneDrive</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/word" class="topNavDropdownLink" data-bi-name="Word" data-bi-slot="103" ms.cmpgrp="content" ms.pgarea="Body">Word</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/excel" class="topNavDropdownLink" data-bi-name="Excel" data-bi-slot="104" ms.cmpgrp="content" ms.pgarea="Body">Excel</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/powerpoint" class="topNavDropdownLink" data-bi-name="PowerPoint" data-bi-slot="105" ms.cmpgrp="content" ms.pgarea="Body">PowerPoint</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/onenote" class="topNavDropdownLink" data-bi-name="OneNote" data-bi-slot="106" ms.cmpgrp="content" ms.pgarea="Body">OneNote</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/sharepoint" class="topNavDropdownLink" data-bi-name="SharePoint" data-bi-slot="107" ms.cmpgrp="content" ms.pgarea="Body">SharePoint</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/teams" class="topNavDropdownLink" data-bi-name="Microsoft Teams" data-bi-slot="108" ms.cmpgrp="content" ms.pgarea="Body">Microsoft Teams</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/yammer" class="topNavDropdownLink" data-bi-name="Yammer" data-bi-slot="109" ms.cmpgrp="content" ms.pgarea="Body">Yammer</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/access" class="topNavDropdownLink" data-bi-name="Access" data-bi-slot="110" ms.cmpgrp="content" ms.pgarea="Body">Access</a></li>

							</ul>
						</li>
						<li class="topNavTopLevelMenuItem topNavDropdownMenuItem">
							<a href="https://support.office.com/zh-cn/article/4414eaaf-0478-48be-9c42-23adc4716658" class="topNavDropdownLink" data-bi-name="安装" data-bi-slot="200" ms.cmpgrp="content" ms.pgarea="Body">安装</a>
						</li>
						<li class="topNavTopLevelMenuItem topNavDropdownMenuItem">
							<a href="https://support.office.com/zh-cn/article/b9582171-fd1f-4284-9846-bdd72bb28426" class="topNavDropdownLink" data-bi-name="帐户" data-bi-slot="300" ms.cmpgrp="content" ms.pgarea="Body">帐户</a>
						</li>
						<li class="topNavTopLevelMenuItem topNavDropdownMenuItem">
							<a href="https://support.office.com/zh-cn/office-training-center" class="topNavDropdownLink" data-bi-name="培训" data-bi-slot="400" ms.cmpgrp="content" ms.pgarea="Body">培训</a>
						</li>
						<li class="topNavTopLevelMenuItem topNavDropdownMenuItem">
							<a href="https://support.office.com/zh-cn/office365admin" class="topNavDropdownLink" data-bi-name="管理员" data-bi-slot="500" ms.cmpgrp="content" ms.pgarea="Body">管理员</a>
						</li>

		</ul>
	</div>

		

		



		<section id="ocHelp" dir="ltr">
			<div id="ocArticle">
				

				<div class="grd main-content zero-margin" id="ocMainContent" role="main">
					<div class="row ocpArticleSizingWrapper">
						

						<div id="supArticleContent" class="col-5-5 " data-bi-area="content">
							

							<!--If multimedia nav, hide the title and Applies To:-->
								<section class="ocpArticleTitleSection">
									<h1>如何更正 VLOOKUP 函数中的 #N/A 错误</h1>
								</section>

							
				<section class="supAppliesToSection" ms.cmpgrp="applies_to" aria-label="本文" dir="ltr">
					<div id="supAppliesToTableContainer">
						<div id="supAppliesToList" class="appliesTo collapsed">
							<span>适用于: </span>
								<span class="appliesToItem">Excel for Office 365</span>
								<span class="appliesToItem">Excel for Office 365 for Mac</span>
								<span class="appliesToItem">Excel 2016</span>
								<span class="appliesToItem">Excel 2013</span>
								<span class="appliesToItem ocHidden">Excel 2010</span>
								<span class="appliesToItem ocHidden">Excel 2007</span>
								<span class="appliesToItem ocHidden">Excel 2016 for Mac</span>
								<span class="appliesToItem ocHidden">Excel for Mac 2011</span>
								<span class="appliesToItem ocHidden">Excel Online</span>
								<span class="appliesToItem ocHidden">Excel for iPad</span>
								<span class="appliesToItem ocHidden">Excel for iPhone</span>
								<span class="appliesToItem ocHidden">Excel for Android 平板电脑版</span>
								<span class="appliesToItem ocHidden">Excel 2019 for Mac</span>
								<span class="appliesToItem ocHidden">Excel for Android 手机版</span>
								<span class="appliesToItem ocHidden">Excel for Windows Phone 10</span>
								<span class="appliesToItem ocHidden">Excel Mobile</span>
							<a tabindex="0" class="appliesToOverflowControl expand font-bold" href="javascript:" ms.interactiontype="11" ms.title="Less applies to" aria-label="按 Enter 键可了解本帮助文章适用的其他 Office 版本。" ms.cmpgrp="content" ms.pgarea="Body" data-bi-bhvr="EXPAND" data-bi-area="applies_to">更多...</a>
							<a tabindex="0" class="appliesToOverflowControl collapse ocHidden font-bold" href="javascript:" ms.interactiontype="11" ms.title="More applies to" ms.cmpgrp="content" ms.pgarea="Body" data-bi-bhvr="REDUCE" data-bi-area="applies_to">更少</a>
						</div>
					</div>
				</section>

							



<article id="ocpArticleContent" class="ocpArticleContent">
  <section class="ocpIntroduction">
    <div class="ocpAlert" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <p class="ocpAlertSection">
        <b class="ocpNote">注意:</b>&nbsp;
          我们希望能够尽快以你的语言为你提供最新的帮助内容。 本页面是自动翻译的，可能包含语法错误或不准确之处。我们的目的是使此内容能对你有所帮助。可以在本页面底部告诉我们此信息是否对你有帮助吗？ 请在此处查看本文的
          <a href="https://support.office.com/en-us/article/e037d763-ffc3-4fae-a909-89c482d389b2" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">英文版本</a>
		  以便参考。
        </p>
    </div>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">本主题介绍最常见的原因的错误的结果在<a href="https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">VLOOKUP</a>函数中，并提供有关改为使用<a href="https://support.office.com/en-us/article/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">INDEX</a>和<a href="https://support.office.com/en-us/article/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">MATCH</a>建议。</p>
    <div class="ocpAlert" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <p class="ocpAlertSection">
        <b class="ocpNote">提示:</b>&nbsp;此外，请参阅<a href="https://support.office.com/en-us/article/Quick-Reference-Card-VLOOKUP-troubleshooting-tips-6fe7fe1b-709b-4958-adfb-9f2a409dcf38?CorrelationId=ee39e0df-07d6-45b7-8d89-c40e6dee83b0&amp;amp;ui=en-US&amp;amp;rs=en-US&amp;amp;ad=US" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">课程摘要卡： VLOOKUP 疑难解答提示</a>其提供方便的 PDF 文件中的 #NA 问题的常见原因。您可以与其他人共享 PDF 或打印出来供自己参考。</p>
    </div>
  </section>
  <section class="ocpSection">
    <h2>问题：查阅值不在 <i class="ocpItalic" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">table_array</i> 参数的第一列中。</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup" class="">VLOOKUP 的一个约束是可仅查找表数组中最左侧的列的值。如果查阅值不在数组第一列中，您将看到 # n/A 错误。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">下表中，我们要检索 Kale 的销售量。 </p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
<img src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/4c03d834-100f-4a35-8896-3942dfe127ce.png" alt="Vlookup 中的 #NA 错误：查阅值不在表数组的第一列中" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500">
</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
    </p><p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup"># N/A 错误结果，因为在查阅值<i class="ocpItalic">"Kale"</i>显示在<i class="ocpItalic">table_array</i>参数 A2:C10 的第二列 （制作）。这种情况下，Excel 将其在中查找列 A，而不是列 b。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <b class="ocpLegacyBold">解决方案</b>： 您可以尝试修复此错误通过调整您 VLOOKUP 引用了正确的列。如果不能，然后尝试移动列。也可能是高度不可行，如果您有大型或复杂的电子表格单元格的值在其他计算结果哪里 — 或者可能有其他逻辑为什么您只需不能移动列的原因。解决方案是使用 INDEX 和 MATCH 函数，可以查找而不考虑其位置位置查阅表格中的一列中的值的组合。请参阅下一节。</p>
  </section>
  <section class="ocpSection">
    <h2>请考虑改用索引/匹配</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <a href="https://support.office.com/en-us/article/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">INDEX</a>和<a href="https://support.office.com/en-us/article/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">MATCH</a>是 VLOOKUP 不符合您的需求的许多情况下很好的选项。索引/匹配的主要优势是您可以查找查阅表格中的任意位置中的一列中的值。函数 INDEX 返回从指定的表/区域的值，根据其位置。匹配返回表/区域中的值的相对位置。使用 INDEX 和 MATCH 配合在公式中表格数组中指定的相对位置的值来查找表/数组中的值。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">有许多优势，而不 VLOOKUP 使用索引/匹配的：</p>
    <ul xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <li>
        <p>
          <b class="ocpLegacyBold">使用 INDEX 和 MATCH，返回的值不需要在同一列中为查阅列。</b>这是不同于 VLOOKUP，其中返回的值有需要在指定的区域。这是否重要？使用 VLOOKUP，您必须知道其中包含返回值的列号。尽管这可能无法在困难，它可以麻烦时您有一个大型表来计算列数。此外，如果您添加/删除列在表格中，您必须重新计算，并更新<b class="ocpLegacyBold">col_index_num</b>参数。使用 INDEX 和 MATCH，没有计数是必需的查阅列是不同于包含返回值的列。</p>
      </li>
      <li>
        <p>
          <b class="ocpLegacyBold">使用 INDEX 和 MATCH，您可以指定行或列的数组中，或同时指定。</b>这意味着您可以在垂直或水平查找值。</p>
      </li>
      <li>
        <p>
          <b class="ocpLegacyBold">INDEX 和 MATCH 可用于在任何列中查找值。</b>与 VLOOKUP 不同，在其中您可以仅查找表中的第一列中的值 — 如果查阅值在第一列，最后一次，或任意位置之间的 INDEX 和 MATCH 正常工作。</p>
      </li>
      <li>
        <p>
          <b class="ocpLegacyBold">INDEX 和 MATCH 提供动态引用的列，其中包含返回值的灵活性。</b>这意味着您可以添加列到表中，而不会断开 INDEX 和 MATCH。VLOOKUP 另一方面，如果您需要将一列添加到表分页符，由于它对表格的静态引用。</p>
      </li>
      <li>
        <p>
          <b class="ocpLegacyBold">INDEX 和 MATCH 更灵活的匹配项。</b>INDEX 和 MATCH 可以查找精确匹配或大于或小于查阅值的值。VLOOKUP 将仅查找的值 （默认） 或确切的值与最匹配。VLOOKUP 还假定默认情况下，表格数组中的第一列按字母顺序排序，并且 VLOOKUP 假设您的表未设置这种方法，将返回表，可能不适用于您正在寻找的数据中的最接近的第一个匹配。</p>
      </li>
    </ul>
    <section class="ocpSection">
      <h3>语法</h3>
      <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">若要生成索引/匹配的语法，您需要使用数组/引用参数从 INDEX 函数和嵌套在其匹配语法。这需要窗体：</p>
      <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
        <b class="ocpLegacyBold">= INDEX(array or reference, MATCH(lookup_value,lookup_array,[match_type])</b>
      </p>
      <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">我们使用索引/匹配替换 VLOOKUP 上面的示例。语法如下所示：</p>
      <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
        <b class="ocpLegacyBold">=INDEX(C2:C10,MATCH(B13,B2:B10,0))</b>
      </p>
      <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">用简单的汉语表达其意思：</p>
      <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
        <i class="ocpItalic">= 索引 (从 c2: c10，将符合返回的值 (Kale，b2: b10 数组中，在其中返回值是对应于 Kale 的第一个值中的某个位置))</i>
      </p>
      <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
<img src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/40c79147-ea5b-419d-bd59-83b84f715a4f.png" alt="可以使用 INDEX 和 MATCH 函数替代 VLOOKUP" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500">
</p>
      <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      </p><p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">该公式在 C2 至 C10 单元格中查找 <b class="ocpLegacyBold">Kale</b>（ B7 单元格）对应的第一个值，并返回 C7 单元格中的值 (<b class="ocpLegacyBold">100</b>)，即与 Kale 匹配的第一个值。</p>
    </section>
  </section>
  <section class="ocpSection">
    <h2>问题：找不到完全匹配项</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">当<b class="ocpLegacyBold">range_lookup</b>参数为 FALSE，并且 VLOOKUP 不能在您的数据中查找精确匹配 — 将返回 # n/A 错误。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <b class="ocpLegacyBold">解决方案</b>： 如果您是确保电子表格中存在相关数据并 VLOOKUP 不捕捉它，需要时间来验证引用的单元格没有隐藏的空格或非打印字符。此外，请确保单元格按照正确的数据类型。例如，包含数字的单元格应作为<b class="ocpLegacyBold">数字</b>，而不是<b class="ocpLegacyBold">文本</b>设置格式。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">此外，考虑使用<a href="https://support.office.com/zh-cn/article/clean-&amp;#20989;&amp;#25968;-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">清理</a>或<a href="https://support.office.com/zh-cn/article/trim-&amp;#20989;&amp;#25968;-410388fa-c5df-49c6-b16c-9e5630b479f9" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">TRIM</a>函数以清理单元格中的数据。</p>
  </section>
  <section class="ocpSection">
    <h2>问题：查阅值小于数组中的最小值</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">如果<b class="ocpLegacyBold">range_lookup</b>参数设置为 TRUE，并且在查阅值小于数组中的最小值-您将看到 # n/A 错误。TRUE 看起来近似匹配数组中并返回最接近的值小于查阅值。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">在以下示例中，查阅值是 <b class="ocpLegacyBold">100</b>，但 B2:C10 区域中不存在小于 100 的值，因此出现错误。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
<img src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/0d51a59f-d0c3-4f2d-ae90-ef6311624898.png" alt="查阅值小于数组中的最小值时 VLOOKUP 中会出现 N/A 错误" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500">
</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
    </p><p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <b class="ocpLegacyBold">解决方案</b>：</p>
    <ul xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <li>
        <p>	根据需要更改查阅值。</p>
      </li>
      <li>
        <p>如果您不能更改查阅值，并且需要具有匹配值更大的灵活性，请考虑使用索引/匹配，而不 VLOOKUP，请参阅本文中上面的部分。与索引/匹配项，您可以查找值大于、 更小，或等于查阅值。使用索引/匹配，而不 VLOOKUP 的详细信息，请参阅本主题中的上一节。</p>
      </li>
    </ul>
  </section>
  <section class="ocpSection">
    <h2>问题：查阅列未按升序排列</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">如果<b class="ocpLegacyBold">range_lookup</b>参数设置为 TRUE，和查找列的其中一个未排序升序 (A 到 Z)，您将看到 # n/A 错误。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
    </p><p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <b class="ocpLegacyBold">解决方案</b>：</p>
    <ul xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <li>
        <p>更改 VLOOKUP 函数来查找精确匹配。若要执行此操作，请<b class="ocpLegacyBold">range_lookup</b>参数设置为<i class="ocpItalic">FALSE</i>。无排序是需要为 FALSE。</p>
      </li>
      <li>
        <p>使用 INDEX/MATCH 函数查找未排序表格中的值。 </p>
      </li>
    </ul>
  </section>
  <section class="ocpSection">
    <h2>问题：值是较长的浮点数</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">如果您有时间值或大型十进制数字在单元格，Excel 将返回 # n/A 错误，由于浮动点精度。浮点数是按照小数点后的数字。（Excel 存储时间值为浮点数。）Excel 不能存储具有非常大的浮动点的数字、 浮动指向函数正常工作，以便将需要数字舍入为 5 个小数位数。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <b class="ocpLegacyBold">解决方案</b>：缩短该数字，使用 <a href="https://support.office.com/zh-cn/article/round-&amp;#20989;&amp;#25968;-c018c5d8-40fb-4053-90b1-b3e7f61a213c" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">ROUND</a> 函数将其四舍五入到五个小数位数。</p>
  </section>
  <section class="ocpSection">
    <h2>你是否有特定函数问题？</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <a href="https://answers.microsoft.com/lang/msoffice/forum/msoffice_excel" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">在 Excel 社区论坛中发布问题</a>
    </p>
  </section>
  <section class="ocpSection">
    <h2>帮助我们改进 Excel</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">是否有关于如何改进下一版 Excel 的建议？如果有，请查看 <a href="https://excel.uservoice.com/" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">Excel User Voice</a> 上的主题。</p>
  </section>
  <section class="ocpSection">
    <h2>另请参阅</h2>
    <ul xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <li>
        <p>
          <a href="https://support.office.com/zh-cn/article/&amp;#22914;&amp;#20309;&amp;#26356;&amp;#27491;-n-a-&amp;#38169;&amp;#35823;-a9708411-f82e-4e1b-8a7e-28c28311b993" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">更正 #N/A 错误</a>
        </p>
      </li>
      <li>
        <p>
          <a href="https://blogs.office.com/2010/10/06/vlookup-no-more-na/" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">VLOOKUP： 没有更多 #NA</a>
        </p>
      </li>
      <li>
        <p>
          <a href="https://support.microsoft.com/en-us/kb/78113" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">浮算术可能会在 Excel 中的不准确的结果</a>
        </p>
      </li>
      <li>
        <p>
          <a href="https://support.office.com/zh-cn/article/&amp;#35838;&amp;#31243;&amp;#25688;&amp;#35201;&amp;#21345;&amp;#65306;-vlookup-&amp;#22797;&amp;#20064;-750fe2ed-a872-436f-92aa-36c17e53f2ee" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">课程摘要卡：VLOOKUP 复习</a>
        </p>
      </li>
      <li>
        <p>
          <a href="https://support.office.com/zh-cn/article/vlookup-&amp;#20989;&amp;#25968;-0bbc8083-26fe-4963-8ab8-93a18ad188a1" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">VLOOKUP 函数</a>
        </p>
      </li>
      <li>
        <p>
          <a href="https://support.office.com/zh-cn/article/excel-&amp;#20013;&amp;#30340;&amp;#20844;&amp;#24335;&amp;#27010;&amp;#36848;-ecfdc708-9162-49e8-b993-c311f47ca173" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">Excel 中的公式概述</a>
        </p>
      </li>
      <li>
        <p>
          <a href="https://support.office.com/zh-cn/article/&amp;#22914;&amp;#20309;&amp;#36991;&amp;#20813;&amp;#25439;&amp;#22351;&amp;#30340;&amp;#20844;&amp;#24335;-8309381d-33e8-42f6-b889-84ef6df1d586" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">如何避免损坏的公式</a>
        </p>
      </li>
      <li>
        <p>
          <a href="https://support.office.com/zh-cn/article/%E4%BD%BF%E7%94%A8%E9%94%99%E8%AF%AF%E6%A3%80%E6%9F%A5%E5%8A%9F%E8%83%BD%E6%A3%80%E6%9F%A5%E5%85%AC%E5%BC%8F%E4%B8%AD%E7%9A%84%E9%94%99%E8%AF%AF-4d4c160b-8d9a-45f1-bec7-75f4b90045f8" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">使用错误检查功能检查公式中的错误</a>
        </p>
      </li>
      <li>
        <p>
          <a href="https://support.office.com/zh-cn/article/excel-&amp;#20989;&amp;#25968;&amp;#65288;&amp;#25353;&amp;#23383;&amp;#27597;&amp;#39034;&amp;#24207;&amp;#65289;-b3944572-255d-4efb-bb96-c6d90033e188" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">所有 Excel 函数 （按字母顺序）</a>
        </p>
      </li>
      <li>
        <p>
          <a href="https://support.office.com/zh-cn/article/excel-&amp;#20989;&amp;#25968;&amp;#65288;&amp;#25353;&amp;#31867;&amp;#21035;&amp;#21015;&amp;#20986;&amp;#65289;-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">所有 Excel 函数 （按类别）</a>
        </p>
      </li>
    </ul>
  </section>
</article>




















							
						</div>
							<div id="DisabledArticleTools"></div>
					</div>
					

					



	<div class="row supArticleContentFooterWrapper">
		<div id="articleContentFooterPadding" class=""></div>
		<div id="ocArticleContentFooter" class="col-5-5">
			<div class="ocArticleFooterSection">
				<div class="ocArticleFooterElementContainer" data-bi-area="article_footer">
											<div class="ocArticleFooterElement">
							<div class="ocArticleFooterElementTitle">
								扩展你的 Office 技能
							</div>
							<a class="ocArticleFooterElementCallToAction" href="https://support.office.com/zh-cn/office-training-center" data-bi-slot="2" ms.cmpgrp="content" ms.pgarea="Body">了解培训</a>
						</div>
											<div class="ocArticleFooterElement">
							<div class="ocArticleFooterElementTitle">
								抢先获得新功能
							</div>
							<a class="ocArticleFooterElementCallToAction" href="https://support.office.com/zh-cn/article/f4208185-b63a-4b68-9c7a-9a32d2411c16" data-bi-slot="3" ms.cmpgrp="content" ms.pgarea="Body">加入 Office 预览体验计划</a>
						</div>
					<div class="ocArticleFooterElement ocArticleFooterClearfix">
					</div>
				</div>
			</div>
		</div>
	</div>

				</div>
			</div>
		</section>

		<div id="ocFooterWrapper">

				<div id="supWrapperToPreventFeedbackFlickering">
					<section id="supFeedbackWrapper" class="supStickyFeedback">
						<div id="supColumnWrapper">
							
	

<div id="supFeedBackContainer">
	<section id="supFB" class="ocFB">
		<div id="supFBCont">
			<form name="smartFeedbackForm" class="smartFeedbackForm supStickyFeedbackMarginBottom" data-sentiment-analysis="true" data-support-available="true">
				<input name="__RequestVerificationToken" type="hidden" value="CbgLFslF8zrtbbweWkztPs5PV0oLPufTmA0H2t7wNsY5iCVZUFPxkrsDtiiZSU3JPE3RyznJBK0DZbK8upDZSWbn3-UbOdtMQ5UpuOsd5Ds1">
				<div class="ocSmartFeedbackBegin" role="region">
					<div id="beginFeedbackHeader" class="supStickyFeedbackHeader">
						<h2>此信息是否有帮助?</h2>
					</div>
					<div class="feedbackButtons">
						<button class="ocFeedbackButton supStickyFeedbackButton feedbackSelection" name="buttonYes" type="button" data-bi-mto="">是</button>
						<button class="ocFeedbackButton supStickyFeedbackButton feedbackSelection" name="buttonNo" type="button" data-bi-mto="">否</button>
					</div>
				</div>
				<div class="ocSmartFeedbackReply ocHidden">
					<div class="supStickyFeedbackHeader">
						<label for="feedbackText" class="ocFeedbackHeaderIfArticleHelpful ocHidden">很好! 还有其他反馈吗?</label>
						<label for="feedbackText" class="ocFeedbackHeaderIfArticleNotHelpful ocHidden">我们应该如何改进?</label>
					</div>
					<div id="ocProductArticleFeedback" class="ocFeedbackMoreInformation ocHidden">
						<label id="radioButtonProduct" class="ocProductArticleRadioContainer">产品
							<input type="radio" name="radio" value="product">
							<span class="ocProductArticleRadioCheckmark"></span>
						</label>
						<label id="radioButtonArticle" class="ocProductArticleRadioContainer">文章
							<input type="radio" name="radio" value="article">
							<span class="ocProductArticleRadioCheckmark"></span>
						</label>
					</div>
					<textarea class="ocSmartFeedbackTextArea" name="feedbackText" rows="6" cols="40" maxlength="250" placeholder="你告诉我们的内容越详细，我们可以提供的帮助就越多。" required=""></textarea>
					<div class="feedbackButtons">
						<button class="ocFeedbackButton supStickyFeedbackButton ocButtonSendComment" type="submit" data-bi-mto="">发送​​</button>
						<button class="ocFeedbackButton supStickyFeedbackButton ocButtonSendNoComment" type="button" data-bi-mto="">不，谢谢</button>
					</div>
				</div>
			</form>
			<div class="ocFeedbackFinalThankYouMessage ocHidden supStickyFeedbackHeader supStickyFeedbackMarginBottom">
				<h2>谢谢您的反馈!</h2>
			</div>
			<div class="ocFeedbackToChat ocHidden supStickyFeedbackHeader supStickyFeedbackMarginBottom">
				<h2>谢谢你的反馈! 可能需要转接到 Office 支持专员。</h2>
				<div class="feedbackButtons">
					<a class="smartFeedbackChatLink ocFeedbackButton" target="_top" ms.cmpgrp="content" ms.pgarea="Body">联系支持人员</a>
				</div>
			</div>
		</div>
	</section>
</div>

							<a href="javascript:" id="supDisableStickyFeedbackButton" class="" ms.interactiontype="11" aria-label="单击以禁用粘黏反馈横幅。" data-bi-bhvr="HIDE" ms.cmpgrp="content" ms.pgarea="Body">×</a>
						</div>
					</section>
				</div>

			
	

    <section id="footerArea" data-m="{&quot;cN&quot;:&quot;footerArea&quot;,&quot;cT&quot;:&quot;Area_coreuiArea&quot;,&quot;id&quot;:&quot;a2Body&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;Body&quot;}" ms.pgarea="Footer">
            <div id="footerRegion" data-region-key="footerregion" data-m="{&quot;cN&quot;:&quot;footerRegion&quot;,&quot;cT&quot;:&quot;Region_coreui-region&quot;,&quot;id&quot;:&quot;r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;a2&quot;}">

    <div id="footerUniversalFooter" data-m="{&quot;cN&quot;:&quot;footerUniversalFooter&quot;,&quot;cT&quot;:&quot;Module_coreui-universalfooter&quot;,&quot;id&quot;:&quot;m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;r1a2&quot;}" data-module-id="Category|footerRegion|footerRegion|footerUniversalFooter|coreui-universalfooter">
        

<footer id="uhf-footer" class="c-uhff context-uhf" data-uhf-mscc-rq="false" data-footer-footprint="/officesupport/officesupportfooter" data-m="{&quot;cN&quot;:&quot;Uhf footer_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;m1r1a2&quot;}">
            <nav class="c-uhff-nav" role="navigation" aria-label="页脚" data-m="{&quot;cN&quot;:&quot;Footer nav_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1m1r1a2&quot;}">
                
                    <div class="c-uhff-nav-row">
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn1_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">新增内容</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/p/surface-go/8v9dp4lnknsz" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_SurfaceGo_nav&quot;,&quot;id&quot;:&quot;n1c1c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">全新 Surface Go </a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/surface/devices/surface-book-2/overview" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_SurfaceBook2_nav&quot;,&quot;id&quot;:&quot;n2c1c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Surface Book 2</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/surface/devices/surface-pro/overview" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_NewSurfacePro_nav&quot;,&quot;id&quot;:&quot;n3c1c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Surface Pro</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.xbox.com/zh-cn/xbox-one-x" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_XboxOneX_nav&quot;,&quot;id&quot;:&quot;n4c1c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Xbox One X</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.xbox.com/zh-cn/xbox-one-s?xr=shellnav" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_XboxOneS_nav&quot;,&quot;id&quot;:&quot;n5c1c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Xbox One S</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/windows/windows-10-apps" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_Windows_10_apps_nav&quot;,&quot;id&quot;:&quot;n6c1c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Windows 10 应用程序</a>
                                            </li>

                                </ul>
                                
                            </div>
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn2_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">应用商店和支持
</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://account.microsoft.com/" data-m="{&quot;cN&quot;:&quot;Footer_StoreandSupport_AccountProfile_nav&quot;,&quot;id&quot;:&quot;n1c2c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c1c1m1r1a2&quot;}" ms.pgarea="Body">帐户个人资料</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/download" data-m="{&quot;cN&quot;:&quot;Footer_StoreandSupport_DownloadCenter_nav&quot;,&quot;id&quot;:&quot;n2c2c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c2c1c1m1r1a2&quot;}" ms.pgarea="Body">下载中心</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://account.microsoft.com/orders" data-m="{&quot;cN&quot;:&quot;Footer_StoreandSupport_OrderTracking_nav&quot;,&quot;id&quot;:&quot;n3c2c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c2c1c1m1r1a2&quot;}" ms.pgarea="Body">订单跟踪</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://support.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_StoreandSupport_Support_nav&quot;,&quot;id&quot;:&quot;n4c2c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c2c1c1m1r1a2&quot;}" ms.pgarea="Body">支持</a>
                                            </li>

                                </ul>
                                
                            </div>
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn3_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">教育</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/education" data-m="{&quot;cN&quot;:&quot;Footer_Education_MicrosoftInEducation_nav&quot;,&quot;id&quot;:&quot;n1c3c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft 教育领域</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/education/products/office/default.aspx" data-m="{&quot;cN&quot;:&quot;Footer_Education_OfficeForStudents_nav&quot;,&quot;id&quot;:&quot;n2c3c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c3c1c1m1r1a2&quot;}" ms.pgarea="Body">适合学生的 Office</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://products.office.com/zh-cn/academic/compare-office-365-education-plans" data-m="{&quot;cN&quot;:&quot;Footer_Education_Office365ForSchools_nav&quot;,&quot;id&quot;:&quot;n3c3c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c3c1c1m1r1a2&quot;}" ms.pgarea="Body">适用于学校的 Office 365</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://azure.microsoft.com/zh-cn/community/education/" data-m="{&quot;cN&quot;:&quot;Footer_MicrosoftAzureInEducation_nav&quot;,&quot;id&quot;:&quot;n4c3c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c3c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft Azure 教育领域</a>
                                            </li>

                                </ul>
                                
                            </div>
                    </div>
                    <div class="c-uhff-nav-row">
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn4_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">企业</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://partner.microsoft.com/zh-cn/" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_Enterprise_nav&quot;,&quot;id&quot;:&quot;n1c4c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">企业</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/sql-server/" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_DataPlatform_nav&quot;,&quot;id&quot;:&quot;n2c4c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">数据平台</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/solution-providers" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_FindASolutionsProvider_nav&quot;,&quot;id&quot;:&quot;n3c4c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">查找解决方案提供商</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://partner.microsoft.com/zh-cn/" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_MicrosoftPartnerResources_nav&quot;,&quot;id&quot;:&quot;n4c4c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft 合作伙伴资源</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/?LinkID=808093" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_MicrosoftAppSource_nav&quot;,&quot;id&quot;:&quot;n5c4c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft AppSource </a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://enterprise.microsoft.com/zh-cn/uncategorized/discrete-manufacturing/" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_ManufacturingAndResources_nav&quot;,&quot;id&quot;:&quot;n6c4c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">制造业与资源</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://enterprise.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_FinanciaServices_nav&quot;,&quot;id&quot;:&quot;n7c4c1c1m1r1a2&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">金融服务</a>
                                            </li>

                                </ul>
                                
                            </div>
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn5_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c5c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">开发人员</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://visualstudio.microsoft.com/" data-m="{&quot;cN&quot;:&quot;Footer_Developer_MicrosoftVisualStudio_nav&quot;,&quot;id&quot;:&quot;n1c5c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft Visual Studio</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://developer.microsoft.com/zh-cn/windows" data-m="{&quot;cN&quot;:&quot;Footer_Developer_WindowsDevCenter_nav&quot;,&quot;id&quot;:&quot;n2c5c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">Windows 开发人员中心</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://msdn.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Developer_MicrosoftDeveloperNetwork_nav&quot;,&quot;id&quot;:&quot;n3c5c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">开发人员网络</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://technet.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Developer_TechNet_nav&quot;,&quot;id&quot;:&quot;n4c5c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">TechNet</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://developer.microsoft.com/zh-cn/store/register" data-m="{&quot;cN&quot;:&quot;Footer_Developer_MicrosoftDeveloperProgram_nav&quot;,&quot;id&quot;:&quot;n5c5c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft 开发人员计划</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://channel9.msdn.com/" data-m="{&quot;cN&quot;:&quot;Footer_Developer_Channel9_nav&quot;,&quot;id&quot;:&quot;n6c5c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">通道 9</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://developer.microsoft.com/zh-cn/office" data-m="{&quot;cN&quot;:&quot;Footer_Developer_OfficeDevCenter_nav&quot;,&quot;id&quot;:&quot;n7c5c1c1m1r1a2&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">Office 开发人员中心</a>
                                            </li>

                                </ul>
                                
                            </div>
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn6_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c6c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">公司</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://careers.microsoft.com/" data-m="{&quot;cN&quot;:&quot;Footer_Company_Careers_nav&quot;,&quot;id&quot;:&quot;n1c6c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">招贤纳士</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/about" data-m="{&quot;cN&quot;:&quot;Footer_Company_AboutMicrosoft_nav&quot;,&quot;id&quot;:&quot;n2c6c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">关于 Microsoft</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://news.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Company_CompanyNews_nav&quot;,&quot;id&quot;:&quot;n3c6c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">公司新闻</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://privacy.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Company_PrivacyAtMicrosoft_nav&quot;,&quot;id&quot;:&quot;n4c6c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft 隐私</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/investor/default.aspx" data-m="{&quot;cN&quot;:&quot;Footer_Company_Investors_nav&quot;,&quot;id&quot;:&quot;n5c6c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">投资人</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/security/default.aspx" data-m="{&quot;cN&quot;:&quot;Footer_Company_Security_nav&quot;,&quot;id&quot;:&quot;n6c6c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">安全性</a>
                                            </li>

                                </ul>
                                
                            </div>
                    </div>
            </nav>
    <div class="c-uhff-base">
                    <a id="locale-picker-link" aria-label="Content Language Selector. Currently set to 中文(中国)" class="c-uhff-link c-uhff-lang-selector c-glyph glyph-world" href="https://store.office.com/worldwide.aspx?rs=zh-cn&amp;cmapid=1" data-m="{&quot;cN&quot;:&quot;locale_picker(CN)_nav&quot;,&quot;id&quot;:&quot;n7c1c1m1r1a2&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}" ms.pgarea="Body">中文(中国)</a>

        <ul role="list" aria-label="Microsoft 企业链接" class="c-list f-bare" data-m="{&quot;cN&quot;:&quot;Corp links_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c8c1c1m1r1a2&quot;,&quot;sN&quot;:8,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <li>
                        <a class="c-uhff-link" href="https://support.office.com/home/contact?ContactUsExperienceEntryPointAssetId=e037d763-ffc3-4fae-a909-89c482d389b2" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Contact Us_nav&quot;,&quot;id&quot;:&quot;n1c8c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body" data-bi-bhvr="CALL">联系我们</a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/?LinkId=248681" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;PrivacyandCookies_nav&quot;,&quot;id&quot;:&quot;n2c8c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">隐私与 Cookie</a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/p/?LinkId=530144" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Termsofuseandsale_nav&quot;,&quot;id&quot;:&quot;n3c8c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">使用和销售条款 </a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="http://go.microsoft.com/?LinkId=9851308" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Trademarks_nav&quot;,&quot;id&quot;:&quot;n4c8c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">商标 </a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/p/?LinkId=316963" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Accessibility_nav&quot;,&quot;id&quot;:&quot;n5c8c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">Office 辅助功能</a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/p/?LinkId=530144" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Legal_nav&quot;,&quot;id&quot;:&quot;n6c8c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">法律</a>
                    </li>

            <li>© Microsoft 2018</li>
            
        </ul>
    </div>
    
</footer>




    </div>
    </div>

    </section>



		</div>
	</div>
	<script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/jquery-1.9.1.min.js.下载"></script>
<script>(window.jQuery)||document.write('<script src="/bundles/jquery"><\/script>');</script>

	
<script defer="" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/stickyFeedback"></script>

<script defer="" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/TopNav"></script>


	<script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/support"></script>

	
	

<script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/a3-892803"></script><script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/meversion" defer=""></script>			<script type="text/javascript">
				$(function() {
					var msPageAreaValue = "Header";
					var msSignInInteractionValue = "11";
					var wcsSignInTextValue = "Sign in";

					function SetConsent() {
						var cookieConsentBannerNeeded = false;
						if (cookieConsentBannerNeeded) {
							var mscc = window.mscc;
							if (mscc && !mscc.hasConsent()) {
								mscc.setConsent();
							}
						}
					}

					var shellOptions = function() {
						return {
							currentMenuItemId: 'shell-main-tab',
							meControlOptions: {
								rpData: {
									msaInfo: {
										signInUrl: "https://login.live.com/login.srf?wa=wsignin1.0\u0026rpsnv=13\u0026ct=1533808990\u0026rver=7.0.6731.0\u0026wp=MBI_SSL\u0026wreply=https:%2F%2Fsupport.office.com%2Fauthredir%3Furl%3Dhttps%253a%252f%252fsupport.office.com%253a443%252fzh-cn%252farticle%252f%252525E5%252525A6%25252582%252525E4%252525BD%25252595%252525E6%2525259B%252525B4%252525E6%252525AD%252525A3-vlookup-%252525E5%25252587%252525BD%252525E6%25252595%252525B0%252525E4%252525B8%252525AD%252525E7%2525259A%25252584-n-a-%252525E9%25252594%25252599%252525E8%252525AF%252525AF-e037d763-ffc3-4fae-a909-89c482d389b2%253fui%253dzh-CN%2526rs%253dzh-CN%2526ad%253dCN%26hurl%3DVLoKZUgRWMSqD9dJgPS7yucqg6NLsmDbCuk1OO8EHqo%253d.PK7lETbQFlcvzjTAlfrlV3imB8%252fNjpNJjekNFGqot34%253d%26ipt%3D0%26si%3D1%26wctx%3Ddd1b4e0d-b136-488e-9669-4c0f413e95bf\u0026lc=1033\u0026id=290950\u0026aadredir=1",
										signOutUrl: "https://login.live.com/logout.srf?ct=1533808991\u0026rver=7.0.6731.0\u0026lc=1033\u0026id=290950\u0026ru=https:%2F%2Fsupport.office.com%2Fauthredir%3Furl%3Dhttps%253a%252f%252fsupport.office.com%253a443%252fzh-cn%252farticle%252f%252525E5%252525A6%25252582%252525E4%252525BD%25252595%252525E6%2525259B%252525B4%252525E6%252525AD%252525A3-vlookup-%252525E5%25252587%252525BD%252525E6%25252595%252525B0%252525E4%252525B8%252525AD%252525E7%2525259A%25252584-n-a-%252525E9%25252594%25252599%252525E8%252525AF%252525AF-e037d763-ffc3-4fae-a909-89c482d389b2%253fui%253dzh-CN%2526rs%253dzh-CN%2526ad%253dCN%26hurl%3DVLoKZUgRWMSqD9dJgPS7yucqg6NLsmDbCuk1OO8EHqo%253d.PK7lETbQFlcvzjTAlfrlV3imB8%252fNjpNJjekNFGqot34%253d%26ipt%3D0%26so%3D1"
									},
									aadInfo: {
										signInUrl: "https://login.microsoftonline.com/common/oauth2/authorize?response_mode=form_post\u0026response_type=id_token+code\u0026scope=openid\u0026nonce=0b183778-cb31-4c93-ac68-353bb8cbac09.636694057905535381\u0026state=https:%2f%2fsupport.office.com%2fzh-cn%2farticle%2f%2525E5%2525A6%252582%2525E4%2525BD%252595%2525E6%25259B%2525B4%2525E6%2525AD%2525A3-vlookup-%2525E5%252587%2525BD%2525E6%252595%2525B0%2525E4%2525B8%2525AD%2525E7%25259A%252584-n-a-%2525E9%252594%252599%2525E8%2525AF%2525AF-e037d763-ffc3-4fae-a909-89c482d389b2%3fui%3dzh-CN%26rs%3dzh-CN%26ad%3dCN\u0026client_id=4b233688-031c-404b-9a80-a4f3f2351f90\u0026redirect_uri=https:%2f%2fsupport.office.com%2fauth%2fsignin",
										signOutUrl: ""
									},
									preferredIdp: window.msCommonShell.SupportedAuthIdp.MSA
								},
								userData: {
								},
								events: {
									onEventLog: function (eventId) {
										if (eventId.toLowerCase() === "signin") {
											SetConsent();
											if (typeof window.awa === 'object') {
												var tags = {
													behavior: window.awa.behavior.SIGNIN,
													actionType: 'CL',
													content: {contentName: 'Sign in button', areaName:'Me control header'}
												}
												awa.ct.captureContentPageAction(tags);
											}
										} else if (eventId.toLowerCase() === "dropdownopen") {
											SetConsent();
										}
									}
								}
							},
							events: {
								onSearch: function (searchForm) {
									occe.AutoSuggestSearchEvent(searchForm, msPageAreaValue, 'false');
								}
							},
							as: {
								callback: function () {}
							}
						};
					};

					// If msCommonShell already exists, load it
					if (window.msCommonShell) {
						window.msCommonShell.load(shellOptions());
					}

					// If msCommonShell doesn't yet exist...
					else {

						// Load the me control once msCommonShell is ready
						window.onShellReadyToLoad = function () {
							window.onShellReadyToLoad = null;
							window.msCommonShell.load(shellOptions());
						};
					}

					// Append returnURL query param to change language control on footer
					// Add returnURL to click instead of updating the URL to hide the encoded return url on hover over change language control
					(function () {
						var returnUrlForChangeLanguageHref = window.location.href;
						var $idOfChangeLanguageonFooter = $('#locale-picker-link');
						var hrefOfChangeLanguageOnFooter = $idOfChangeLanguageonFooter.attr('href');

						if (hrefOfChangeLanguageOnFooter) {
							$idOfChangeLanguageonFooter.on('click keypress', function (e) {
								e.preventDefault();
								if (occe.eventHelpers.eventIsClick(e) || occe.eventHelpers.eventIsEnterKeypress(e)) {
									var newChangeLanguageOnFooterUrl = occe.updateQueryStringParameter('returnURL', encodeURIComponent(returnUrlForChangeLanguageHref), hrefOfChangeLanguageOnFooter);
									window.location.href = newChangeLanguageOnFooterUrl;
								}
							});
						}
					})();
				});
			</script>
				


	<script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/a3-892803"></script><script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/meversion" defer=""></script>			<script type="text/javascript">
				$(function() {
				})
			</script>


	<script defer="" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/article"></script>


	

	


	<script id="supResourcesScript" type="text/javascript">
			$(function() {
				if (occe && occe.Resources) {
					occe.Resources.addLocalizedStrings({"L_ArticleTools_LiveIcon_Description":"Live button","L_ArticleTools_PreviewIcon_Description":"Preview button","L_TabControl_AriaLabel_FirstTab":"选项卡列表。有 {0} 个选项卡可用。","L_TabControl_AriaLabel_TabCollapsed":"{0}。已折叠。","L_TabControl_AriaLabel_TabExpanded":"{0}。已展开。","L_TabControl_AriaLabel_TabsOverflowDropdownIcon_Collapsed":"更多选项卡下拉列表。已折叠。按 Enter 键可展开下拉列表。","L_TabControl_AriaLabel_TabsOverflowDropdownIcon_Expanded":"更多选项卡下拉列表。已展开。按 Tab 键以通过可用选项卡进行导航。","L_CardControl_AriaLabel_DescriptiveCard_FooterText":"培训课程库。{0} 个培训课程(共 {1} 个)。{2}。每个课程有 {3} 个视频。按 Enter 键可启动课程，按 Tab 键可收听下一堂课。","L_CardControl_AriaLabel_DescriptiveCard_MinutesSeconds":"培训课程库。第 {0} 个培训课程，共 {1} 个。{2}。本课程共 {3} 分 {4} 秒。按 Enter 键启动课程，按 Tab 键收听下一课程。","L_CardControl_AriaLabel_DescriptiveCard_MinuteSeconds":"培训课程库。第 {0} 个培训课程，共 {1} 个。{2}。本课程共 {3} 分 {4} 秒。按 Enter 键启动课程，按 Tab 键收听下一课程。","L_CardControl_AriaLabel_DescriptiveCard_MinutesSecond":"培训课程库。第 {0} 个培训课程，共 {1} 个。{2}。本课程共 {3} 分 {4} 秒。按 Enter 键启动课程，按 Tab 键收听下一课程。","L_CardControl_AriaLabel_DescriptiveCard_MinuteSecond":"培训课程库。第 {0} 个培训课程，共 {1} 个。{2}。本课程共 {3} 分 {4} 秒。按 Enter 键启动课程，按 Tab 键收听下一课程。","L_CardControl_AriaLabel_Card_FooterText":"{0} 个课程(共 {1} 个)。{2}。存在 {3} 个视频。按 Enter 键可启动视频。","L_CardControl_AriaLabel_Card_MinutesSeconds":"第 {0} 个课程，共 {1} 个。{2}。课程长度: {3} 分 {4} 秒。","L_CardControl_AriaLabel_Card_MinuteSeconds":"第 {0} 个课程，共 {1} 个。{2}。课程长度: {3} 分 {4} 秒。","L_CardControl_AriaLabel_Card_MinutesSecond":"第 {0} 个课程，共 {1} 个。{2}。课程长度: {3} 分 {4} 秒。","L_CardControl_AriaLabel_Card_MinuteSecond":"第 {0} 个课程，共 {1} 个。{2}。课程长度: {3} 分 {4} 秒。","L_CardControl_AriaLabel_PreviousButton":"按 Enter 键收听之前的课程。","L_CardControl_AriaLabel_NextButton":"按 Enter 键收听更多可听课程。","L_EditInC3":"edit","L_IA_Feedback_Recorded":"感谢你提供反馈。","L_TrainingTips_AriaLabel_NextArrow":"按 Enter 键收听下一提示。","L_TrainingTips_AriaLabel_PrevArrow":"按 Enter 键收听上一提示。","L_TrainingTips_AriaLabel_Close":"对话框关闭按钮。按 Enter 键可折叠提示对话框。"});
					occe.Resources.addSettings({"OdcSup_C3EntryPoint_Enabled":"True","OdcSup_C3EntryPoint_UrlFormat":"https://c3web.trafficmanager.net/topic/{0}","OdcSup_ContextTabActivation_SignIn":"True"});
				}
			});
	</script>



	


<script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/angular"></script>
<script defer="" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/autoSuggest"></script>


		<script type="text/javascript" src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/broker.js.下载" defer=""></script>


<script type="text/javascript">


	var config = {
		syncMuid: (typeof OOGlobal === "undefined" || typeof OOGlobal.IsCookieConsentRequired  === "undefined")
			? true : (!OOGlobal.IsCookieConsentRequired || (typeof(mscc) != "undefined" && mscc.hasConsent())),
		autoCapture: {
			scroll: false,
			resize: true
		},
		coreData: {
			appId: 'support.office.com',
			pageTags: {}
		},
		isLoggedIn: false,
		shareAuthStatus: true,
		authMethod: Number(0),
		callback: {
			pageViewPageTags: returnPageInfo,
			pageActionPageTags: returnPageInfo,
			contentUpdatePageTags: returnPageInfo
		}
	};

	if (occe.experimentRunningOnPage()) {
		occe.updateAwaExperimentTags(config);
	};

	if (occe.elementIsOnPage('.ocpEditArticleLink')) {
		config.coreData.pageTags['ver'] = 'editShown';
	}

	var $conditionalContentLocalizationElements = $("*[conditionalContentLocalization]");
	if ($conditionalContentLocalizationElements.length) {
		config.coreData.pageTags = config.coreData.pageTags || {};
		config.coreData.pageTags['conditionalContentLocalization'] = $conditionalContentLocalizationElements.first().attr('conditionalContentLocalization');

		$conditionalContentLocalizationElements.slice(1).each(function() {
			config.coreData.pageTags['conditionalContentLocalization'] += ',' + $(this).attr('conditionalContentLocalization');
		});
	}

	awa.init(config);

	function returnPageInfo() {
		return config.coreData.pageTags;
	};
</script>
		<script type="text/javascript">
			$(document).ready(function() {
				var divDisabledArticleTools = $(document).find('#DisabledArticleTools');

				occe.articleTools = (function createArticleToolsModule() {
					function displayTools() {
						$.ajax(
							{
								url: '/zh-cn/article/articletools/e037d763-ffc3-4fae-a909-89c482d389b2?version=7\u0026storageType=Live\u0026isHoverEnabled=True\u0026assetOwnerAlias=chrsm%40microsoft.com%3Bmaxcontentfeedback%40microsoft.com\u0026mailToUri=mailto%3Achrsm%40microsoft.com%3Bmaxcontentfeedback%40microsoft.com%3Fsubject%3DFeedback%2520on%2520%2522%25e5%25a6%2582%25e4%25bd%2595%25e6%259b%25b4%25e6%25ad%25a3%2520VLOOKUP%2520%25e5%2587%25bd%25e6%2595%25b0%25e4%25b8%25ad%25e7%259a%2584%2520%2523N%252fA%2520%25e9%2594%2599%25e8%25af%25af%2522%2520%255be037d763-ffc3-4fae-a909-89c482d389b2%255d',
								context: document.body
							}
						).done(function(res) {
							$(divDisabledArticleTools).replaceWith(res);

							var articleToolsDisplayMode = $(document).find('#supArticleTool');
							if (articleToolsDisplayMode) {
								var $articleContentRoot = $(document).find('#supArticleContent');
								if ($articleContentRoot.hasClass("col-5-5")) {
									$articleContentRoot.removeClass("col-5-5").addClass("col-4-5");
								}
								else if ($articleContentRoot.hasClass("col-3-4")) {
									$articleContentRoot.removeClass("col-3-4").addClass("col-3-5");
								}

								var $lefNaveViewRoot = $(document).find('#supLeftNav');
								if ($lefNaveViewRoot.hasClass("col-1-4")) {
									$lefNaveViewRoot.removeClass("col-1-4").addClass("col-1-5");
								}

								var $multiMediaLeftNavRoot = $(document).find('#supMultimediaLeftNav');
								if ($multiMediaLeftNavRoot.hasClass("col-1-4")) {
									$multiMediaLeftNavRoot.removeClass("col-1-4").addClass("col-1-5");
								}

								var $articleContentFooterPadding = $(document).find('#articleContentFooterPadding');
								if ($articleContentFooterPadding.hasClass("col-1-4")) {
									$articleContentFooterPadding.removeClass("col-1-4").addClass("col-1-5");
								}

								var $articleContentFooter = $(document).find('#ocArticleContentFooter');
								if ($articleContentFooter.hasClass("col-5-5")) {
									$articleContentFooter.removeClass("col-5-5").addClass("col-4-5");
								}
								else if ($articleContentFooter.hasClass("col-3-4")) {
									$articleContentFooter.removeClass("col-3-4").addClass("col-3-5");
								}
							}
						});
					}

					return{
						displayTools: displayTools
					}
				})();
			});
		</script>
			<script type="text/javascript">
			$(function(){
				occe.articleToolsLogger.sendEventLogging(false);
				occe.c3EditLinkLogger.sendEventLogging(false);
			});
		</script>


<script src="./如何更正 VLOOKUP 函数中的 #N_A 错误 - Office 支持_files/broker-config.js.下载"></script><div id="meControlDropdown" class="msame_Drop_root" style="display: none;" aria-expanded="false"><div tabindex="0" class="msame_focus_trap" aria-hidden="true"></div><div class="msame_Drop_topb"></div><div class="msame_Drop_content" role="dialog" tabindex="-1" aria-label="你的帐户"><div class="msame_Drop_active"></div><div class="msame_Drop_rewards" style="display: none;"></div><div class="msame_Drop_account"></div><div class="msame_Drop_links" style="display: none;"><div class="msame_Drop_links_list"></div></div><div class="msame_Drop_signIn"><div id="msame_si0" class="msame_Drop_SI" data-mc-m="{&quot;id&quot;:&quot;signIn&quot;,&quot;aN&quot;:&quot;Me Control Dropdown&quot;,&quot;cT&quot;:&quot;Link&quot;}"><a href="https://support.office.com/zh-cn/article/%E5%A6%82%E4%BD%95%E6%9B%B4%E6%AD%A3-vlookup-%E5%87%BD%E6%95%B0%E4%B8%AD%E7%9A%84-n-a-%E9%94%99%E8%AF%AF-e037d763-ffc3-4fae-a909-89c482d389b2#" target="_self" class="msame_TxtTrunc">使用另一个帐户登录</a></div></div><div class="msame_Drop_signOut"></div><div class="msame_Drop_accts" style="display: none;"><div class="msame_Drop_sep"></div><div class="msame_Drop_accts_list"></div></div></div><div tabindex="0" class="msame_focus_trap" aria-hidden="true"></div></div></body></html>